Overview

This report shows sales discounts by store, employee, style or discount type. It supports investigation of sales discounts; helping for example to identify discount by employee or discount reason.

It supports date, store and discount type criteria selection with drill through to individual transactions.

Custom terminology allows you to define the retail terminology used within your business. Once defined, terminology automatically appears on criteria forms and reports. For more information on defining custom terminology refer to the article Custom Terminology.

Criteria Form

Refer to the article Report Criteria Form Standard Field Operation for help with the standard criteria form fields.

The following table describes the operation of non-standard fields where appropriate.

Field	Description
Select Discount By	This drop-down field allows the user to select the type of discount to be reported on.
Selection	This field will be available depending on the selection of Select Discount By. It further narrows the criteria to report on.
Group By	This drop-down field defines the first column in the report. It identifies the column that can be drilled down on in the report.
Show	This drop down field allows the user to select the percent of discount shown in the report.
%	This numeric field will be available depending on the selection of the Show field. It further narrows the criteria by putting a discount percentage in where the discount percent is greater than.

Reports

Refer to the section Understanding the Intelligence Store Data for help with the standard values included in Retail Arena reporting.

The following table describes non-standard columns where appropriate.

Column	Description
Tran Count	This column shows the number of transactions in total for the employee.
Disc Tran Count	This column shows the number of transactions with discounted items.
% Trans Discounted	This column shows the percentage of transactions with discounted items.
Sale Qty	This column shows the number of units sold against the transactions.
Curr Retail	This column shows the retail value of sales before discount was applied.
Sale Value	This column shows the dollar amount of sales after the discount has been applied.
Sale Disc	This column shows the difference between current retail and sale value.
% of Retail	This column shows

Remarks

Technical Reference

This section contains technical information about the various source objects for this report and parameters and customization that affect the reports operation. Refer to the article Form Customization and Parameters to understand how parameters, form customization, and security settings affect report and report criteria form operations.

Report Master

Report Index 1

Report Index 2

Report Index 3

Report Index 4

Property	Value
Form Name	Arena_DiscountExceptionReport
Form Customization JScript File Name	Arena_DiscountExceptionReport.js
Report Definition Name	Arena_DiscountExceptionReport
Permission Name	Arena_DiscountExceptionReport

Property	Value
RDL Name	DiscountExceptionByStateBrandDivision.rdl
Stored Procedure Name	Arena_DiscountExceptionByStore
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	No
Honours the System::AggregateSalesIncludeNonInventory parameter.	No however non-inventory items are explicitly excluded in the query.
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Property	Value
RDL Name	DiscountExceptionByReasonCode.rdl
Stored Procedure Name	Arena_DiscountExceptionByDiscountReason
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	No
Honours the System::AggregateSalesIncludeNonInventory parameter.	No however non-inventory items are explicitly excluded in the query.
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Property	Value
RDL Name	DiscountExceptionByStyle.rdl
Stored Procedure Name	Arena_DiscountExceptionByStyle
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	No
Honours the System::AggregateSalesIncludeNonInventory parameter.	No however non-inventory items are explicitly excluded in the query.
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Property	Value
RDL Name	DiscountExceptionByEmployee.rdl
Stored Procedure Name	Arena_DiscountExceptionByEmployee
Supports Enhanced Store Security (See System::StoreEnhancedSecurityEnabled paramter).	No
Supports Enhanced Product Security (See System::ProductEnhancedSecurityEnabled paramter)	No
Supports Currency Conversion	No
Honours the System::AggregateSalesIncludeNonInventory parameter.	No however non-inventory items are explicitly excluded in the query.
Honours the System::SalesAndTargetsIncludeTax parameter.	No
Honours the System::UseConcessionStoreSales parameter.	No
Honours the System::ReleaseQuantityCalculationMethod parameter.	No
Uses the LiveDataViews::Store_Employee_Day_Values parameter.	No
Uses the LiveDataViews::Current_Stock parameter.	No

Arena User Documentation
Discount Exception Report
Send Feedback